Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	8569
Missing cells	15939
Missing cells (%)	14.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	870.4 KiB
Average record size in memory	104.0 B

Variable types

Categorical	1
Numeric	11
Unsupported	1

Alerts

`time` has a high cardinality: 281 distinct values	High cardinality
`SDDY` is highly correlated with `GZDY` and 1 other fields	High correlation
`XCLL` is highly correlated with `XLCS`	High correlation
`GZDY` is highly correlated with `SDDY` and 1 other fields	High correlation
`PJDY` is highly correlated with `SDDY` and 1 other fields	High correlation
`XLCS` is highly correlated with `XCLL`	High correlation
`SDDY` is highly correlated with `GZDY` and 1 other fields	High correlation
`XCLL` is highly correlated with `LSP` and 1 other fields	High correlation
`LSP` is highly correlated with `XCLL`	High correlation
`GZDY` is highly correlated with `SDDY` and 1 other fields	High correlation
`PJDY` is highly correlated with `SDDY` and 1 other fields	High correlation
`XLCS` is highly correlated with `XCLL`	High correlation
`SDDY` is highly correlated with `GZDY` and 1 other fields	High correlation
`XCLL` is highly correlated with `XLCS`	High correlation
`GZDY` is highly correlated with `SDDY` and 1 other fields	High correlation
`PJDY` is highly correlated with `SDDY` and 1 other fields	High correlation
`XLCS` is highly correlated with `XCLL`	High correlation
`SDDY` is highly correlated with `LSP` and 3 other fields	High correlation
`XCLL` is highly correlated with `LSP`	High correlation
`LSP` is highly correlated with `SDDY` and 1 other fields	High correlation
`GZDY` is highly correlated with `SDDY` and 2 other fields	High correlation
`PJDY` is highly correlated with `SDDY` and 2 other fields	High correlation
`number` is highly correlated with `SDDY` and 2 other fields	High correlation
`SDDY` has 194 (2.3%) missing values	Missing
`XCLL` has 218 (2.5%) missing values	Missing
`LSP` has 2113 (24.7%) missing values	Missing
`YHLND` has 1036 (12.1%) missing values	Missing
`DJWD` has 1997 (23.3%) missing values	Missing
`FZB` has 1036 (12.1%) missing values	Missing
`GZDY` has 194 (2.3%) missing values	Missing
`PJDY` has 194 (2.3%) missing values	Missing
`XLCS` has 194 (2.3%) missing values	Missing
`ZZ` has 194 (2.3%) missing values	Missing
`list` has 8569 (100.0%) missing values	Missing
`DJWD` is highly skewed (γ1 = -52.51151413)	Skewed
`list` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-02-13 14:10:16.150822
Analysis finished	2023-02-13 14:10:42.845796
Duration	26.69 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

time
Categorical

HIGH CARDINALITY

Distinct	281
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Memory size	67.1 KiB

2022-02-24 00:00:00	39
2022-02-19 00:00:00	39
2022-02-21 00:00:00	39
2022-02-22 00:00:00	39
2022-02-23 00:00:00	39
Other values (276)	8374

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021-08-07 00:00:00
2nd row	2021-08-09 00:00:00
3rd row	2021-08-10 00:00:00
4th row	2021-08-11 00:00:00
5th row	2021-08-12 00:00:00

Common Values

Value	Count	Frequency (%)
2022-02-24 00:00:00	39	0.5%
2022-02-19 00:00:00	39	0.5%
2022-02-21 00:00:00	39	0.5%
2022-02-22 00:00:00	39	0.5%
2022-02-23 00:00:00	39	0.5%
2022-02-25 00:00:00	39	0.5%
2022-02-26 00:00:00	39	0.5%
2022-02-27 00:00:00	39	0.5%
2022-02-28 00:00:00	39	0.5%
2022-03-01 00:00:00	39	0.5%
Other values (271)	8179	95.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	8569	50.0%
2022-02-24	39	0.2%
2022-04-20	39	0.2%
2022-04-13	39	0.2%
2022-04-14	39	0.2%
2022-04-15	39	0.2%
2022-04-16	39	0.2%
2022-04-17	39	0.2%
2022-04-18	39	0.2%
2022-04-19	39	0.2%
Other values (272)	8218	48.0%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

SDDY
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	131
Distinct (%)	1.6%
Missing	194
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	4.02483606

Minimum	3.93
Maximum	4.13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.1 KiB

Quantile statistics

Minimum	3.93
5-th percentile	3.945
Q1	3.965
median	4.03
Q3	4.08
95-th percentile	4.105
Maximum	4.13
Range	0.2
Interquartile range (IQR)	0.115

Descriptive statistics

Standard deviation	0.05867207765
Coefficient of variation (CV)	0.01457750745
Kurtosis	-1.525238936
Mean	4.02483606
Median Absolute Deviation (MAD)	0.055
Skewness	-0.0472572208
Sum	33708.002
Variance	0.003442412695
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.95	1028	12.0%
4.08	636	7.4%
4.09	480	5.6%
3.94	365	4.3%
4.1	344	4.0%
4.085	343	4.0%
4.095	310	3.6%
3.97	289	3.4%
4.065	285	3.3%
4.02	280	3.3%
Other values (121)	4015	46.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.93	7	0.1%
3.934	1	< 0.1%
3.94	365	4.3%
3.943	2	< 0.1%
3.945	192	2.2%
3.948	2	< 0.1%
3.95	1028	12.0%
3.951	1	< 0.1%
3.953	1	< 0.1%
3.954	2	< 0.1%

Value	Count	Frequency (%)
4.13	21	0.2%
4.125	32	0.4%
4.12	43	0.5%
4.118	2	< 0.1%
4.115	139	1.6%
4.114	1	< 0.1%
4.112	1	< 0.1%
4.111	3	< 0.1%
4.11	96	1.1%
4.108	1	< 0.1%

XCLL
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	13
Distinct (%)	0.2%
Missing	218
Missing (%)	2.5%
Infinite	0
Infinite (%)	0.0%
Mean	2740.953179

Minimum	2560
Maximum	2820
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.1 KiB

Quantile statistics

Minimum	2560
5-th percentile	2650
Q1	2710
median	2730
Q3	2790
95-th percentile	2790
Maximum	2820
Range	260
Interquartile range (IQR)	80

Descriptive statistics

Standard deviation	58.30891582
Coefficient of variation (CV)	0.02127322577
Kurtosis	-0.6442398742
Mean	2740.953179
Median Absolute Deviation (MAD)	60
Skewness	-0.6898089522
Sum	22889700
Variance	3399.929664
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
2790	3703	43.2%
2730	1673	19.5%
2650	1083	12.6%
2710	807	9.4%
2820	342	4.0%
2620	265	3.1%
2700	169	2.0%
2670	160	1.9%
2590	84	1.0%
2740	34	0.4%
Other values (3)	31	0.4%
(Missing)	218	2.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2560	10	0.1%
2590	84	1.0%
2620	265	3.1%
2640	20	0.2%
2650	1083	12.6%
2670	160	1.9%
2700	169	2.0%
2710	807	9.4%
2730	1673	19.5%
2740	34	0.4%

Value	Count	Frequency (%)
2820	342	4.0%
2790	3703	43.2%
2760	1	< 0.1%
2740	34	0.4%
2730	1673	19.5%
2710	807	9.4%
2700	169	2.0%
2670	160	1.9%
2650	1083	12.6%
2640	20	0.2%

LSP
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	31
Distinct (%)	0.5%
Missing	2113
Missing (%)	24.7%
Infinite	0
Infinite (%)	0.0%
Mean	45.05913879

Minimum	2
Maximum	90
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.1 KiB

Quantile statistics

Minimum	2
5-th percentile	8
Q1	27
median	30
Q3	80
95-th percentile	90
Maximum	90
Range	88
Interquartile range (IQR)	53

Descriptive statistics

Standard deviation	29.40898407
Coefficient of variation (CV)	0.6526752367
Kurtosis	-1.364994285
Mean	45.05913879
Median Absolute Deviation (MAD)	20
Skewness	0.4772410994
Sum	290901.8
Variance	864.888344
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
90	1134	13.2%
80	768	9.0%
28	759	8.9%
29	588	6.9%
27	543	6.3%
30	467	5.4%
9	332	3.9%
31	293	3.4%
70	284	3.3%
8	254	3.0%
Other values (21)	1034	12.1%
(Missing)	2113	24.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	6	0.1%
2.8	1	< 0.1%
3	9	0.1%
4	24	0.3%
5	22	0.3%
6	44	0.5%
7	102	1.2%
8	254	3.0%
9	332	3.9%
10	147	1.7%

Value	Count	Frequency (%)
90	1134	13.2%
80	768	9.0%
70	284	3.3%
60	108	1.3%
50	63	0.7%
40	14	0.2%
34	7	0.1%
33	21	0.2%
32	112	1.3%
31	293	3.4%

YHLND
Real number (ℝ_≥0)

MISSING

Distinct	162
Distinct (%)	2.2%
Missing	1036
Missing (%)	12.1%
Infinite	0
Infinite (%)	0.0%
Mean	1.86610381

Minimum	1.2
Maximum	3.67
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.1 KiB

Quantile statistics

Minimum	1.2
5-th percentile	1.44
Q1	1.65
median	1.82
Q3	2.03
95-th percentile	2.45
Maximum	3.67
Range	2.47
Interquartile range (IQR)	0.38

Descriptive statistics

Standard deviation	0.3136628014
Coefficient of variation (CV)	0.1680843262
Kurtosis	1.435330286
Mean	1.86610381
Median Absolute Deviation (MAD)	0.18
Skewness	0.9076692507
Sum	14057.36
Variance	0.098384353
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.79	169	2.0%
1.63	167	1.9%
1.98	140	1.6%
1.8	140	1.6%
1.71	138	1.6%
1.67	136	1.6%
1.75	131	1.5%
1.68	131	1.5%
1.76	129	1.5%
1.83	127	1.5%
Other values (152)	6125	71.5%
(Missing)	1036	12.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.2	45	0.5%
1.21	22	0.3%
1.27	11	0.1%
1.28	14	0.2%
1.29	12	0.1%
1.3	9	0.1%
1.31	2	< 0.1%
1.32	2	< 0.1%
1.33	11	0.1%
1.34	14	0.2%

Value	Count	Frequency (%)
3.67	1	< 0.1%
3.56	1	< 0.1%
3.32	2	< 0.1%
3.23	3	< 0.1%
3.18	3	< 0.1%
3.15	6	0.1%
3.1	7	0.1%
3.07	2	< 0.1%
3.02	4	< 0.1%
2.99	2	< 0.1%

DJWD
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	49
Distinct (%)	0.7%
Missing	1997
Missing (%)	23.3%
Infinite	0
Infinite (%)	0.0%
Mean	934.0286062

Minimum	93
Maximum	1001
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.1 KiB

Quantile statistics

Minimum	93
5-th percentile	925
Q1	930
median	934
Q3	938
95-th percentile	944
Maximum	1001
Range	908
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	11.98351873
Coefficient of variation (CV)	0.01282992688
Kurtosis	3693.018902
Mean	934.0286062
Median Absolute Deviation (MAD)	4
Skewness	-52.51151413
Sum	6138436
Variance	143.6047211
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
934	490	5.7%
932	468	5.5%
933	462	5.4%
931	461	5.4%
936	434	5.1%
935	430	5.0%
930	386	4.5%
937	350	4.1%
929	319	3.7%
938	311	3.6%
Other values (39)	2461	28.7%
(Missing)	1997	23.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
93	1	< 0.1%
916	1	< 0.1%
917	2	< 0.1%
918	1	< 0.1%
919	7	0.1%
920	32	0.4%
921	32	0.4%
922	48	0.6%
923	55	0.6%
924	100	1.2%

Value	Count	Frequency (%)
1001	1	< 0.1%
994	1	< 0.1%
992	1	< 0.1%
971	1	< 0.1%
967	1	< 0.1%
964	1	< 0.1%
962	2	< 0.1%
957	6	0.1%
955	2	< 0.1%
954	4	< 0.1%

FZB
Real number (ℝ_≥0)

MISSING

Distinct	37
Distinct (%)	0.5%
Missing	1036
Missing (%)	12.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.617042347

Minimum	2.46
Maximum	2.82
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.1 KiB

Quantile statistics

Minimum	2.46
5-th percentile	2.53
Q1	2.58
median	2.61
Q3	2.65
95-th percentile	2.72
Maximum	2.82
Range	0.36
Interquartile range (IQR)	0.07

Descriptive statistics

Standard deviation	0.05424162555
Coefficient of variation (CV)	0.02072630793
Kurtosis	0.7614829948
Mean	2.617042347
Median Absolute Deviation (MAD)	0.03
Skewness	0.4715222202
Sum	19714.18
Variance	0.002942153942
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
2.6	739	8.6%
2.61	722	8.4%
2.62	670	7.8%
2.59	604	7.0%
2.63	500	5.8%
2.58	481	5.6%
2.65	470	5.5%
2.57	402	4.7%
2.56	380	4.4%
2.64	370	4.3%
Other values (27)	2195	25.6%
(Missing)	1036	12.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.46	6	0.1%
2.47	10	0.1%
2.48	41	0.5%
2.49	25	0.3%
2.5	64	0.7%
2.51	59	0.7%
2.52	64	0.7%
2.53	120	1.4%
2.54	93	1.1%
2.55	205	2.4%

Value	Count	Frequency (%)
2.82	7	0.1%
2.81	5	0.1%
2.8	11	0.1%
2.79	10	0.1%
2.78	33	0.4%
2.77	16	0.2%
2.76	28	0.3%
2.75	44	0.5%
2.74	94	1.1%
2.73	72	0.8%

GZDY
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	370
Distinct (%)	4.4%
Missing	194
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	4.070502567

Minimum	2.265
Maximum	4.754
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.1 KiB

Quantile statistics

Minimum	2.265
5-th percentile	3.968
Q1	4.009
median	4.072
Q3	4.128
95-th percentile	4.18
Maximum	4.754
Range	2.489
Interquartile range (IQR)	0.119

Descriptive statistics

Standard deviation	0.07316633188
Coefficient of variation (CV)	0.01797476618
Kurtosis	44.09093041
Mean	4.070502567
Median Absolute Deviation (MAD)	0.059
Skewness	-1.60320741
Sum	34090.459
Variance	0.00535331212
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.145	61	0.7%
4.126	56	0.7%
4.117	56	0.7%
4.14	54	0.6%
4.131	54	0.6%
3.987	53	0.6%
3.997	53	0.6%
4.001	53	0.6%
4.138	52	0.6%
3.998	52	0.6%
Other values (360)	7831	91.4%
(Missing)	194	2.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.265	1	< 0.1%
3.86	1	< 0.1%
3.871	2	< 0.1%
3.876	1	< 0.1%
3.882	1	< 0.1%
3.884	2	< 0.1%
3.885	1	< 0.1%
3.889	2	< 0.1%
3.89	1	< 0.1%
3.893	1	< 0.1%

Value	Count	Frequency (%)
4.754	1	< 0.1%
4.347	1	< 0.1%
4.32	1	< 0.1%
4.317	1	< 0.1%
4.316	1	< 0.1%
4.302	1	< 0.1%
4.299	2	< 0.1%
4.292	1	< 0.1%
4.291	1	< 0.1%
4.29	1	< 0.1%

PJDY
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	335
Distinct (%)	4.0%
Missing	194
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	4.068954746

Minimum	2.265
Maximum	4.754
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.1 KiB

Quantile statistics

Minimum	2.265
5-th percentile	3.969
Q1	4.009
median	4.072
Q3	4.125
95-th percentile	4.168
Maximum	4.754
Range	2.489
Interquartile range (IQR)	0.116

Descriptive statistics

Standard deviation	0.06984958066
Coefficient of variation (CV)	0.01716646781
Kurtosis	52.98699953
Mean	4.068954746
Median Absolute Deviation (MAD)	0.057
Skewness	-1.944666258
Sum	34077.496
Variance	0.004878963918
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.117	70	0.8%
4.131	64	0.7%
4.137	64	0.7%
4.121	62	0.7%
4.132	62	0.7%
4.12	61	0.7%
4.124	61	0.7%
4.128	61	0.7%
4.13	60	0.7%
4.127	57	0.7%
Other values (325)	7753	90.5%
(Missing)	194	2.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.265	1	< 0.1%
3.86	1	< 0.1%
3.871	2	< 0.1%
3.878	1	< 0.1%
3.884	1	< 0.1%
3.885	1	< 0.1%
3.889	1	< 0.1%
3.89	1	< 0.1%
3.897	1	< 0.1%
3.899	1	< 0.1%

Value	Count	Frequency (%)
4.754	1	< 0.1%
4.347	1	< 0.1%
4.32	1	< 0.1%
4.316	1	< 0.1%
4.303	1	< 0.1%
4.302	1	< 0.1%
4.29	2	< 0.1%
4.284	1	< 0.1%
4.273	1	< 0.1%
4.269	1	< 0.1%

XLCS
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	719
Distinct (%)	8.6%
Missing	194
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	1762.579343

Minimum	0
Maximum	2352
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	67.1 KiB

Quantile statistics

Minimum	0
5-th percentile	1574
Q1	1681
median	1756
Q3	1840
95-th percentile	1982.3
Maximum	2352
Range	2352
Interquartile range (IQR)	159

Descriptive statistics

Standard deviation	132.5019366
Coefficient of variation (CV)	0.07517501955
Kurtosis	19.12434118
Mean	1762.579343
Median Absolute Deviation (MAD)	79
Skewness	-1.246276278
Sum	14761602
Variance	17556.7632
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1754	41	0.5%
1731	41	0.5%
1737	40	0.5%
1671	40	0.5%
1738	40	0.5%
1785	38	0.4%
1773	36	0.4%
1736	35	0.4%
1740	34	0.4%
1768	34	0.4%
Other values (709)	7996	93.3%
(Missing)	194	2.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4	< 0.1%
7	1	< 0.1%
785	1	< 0.1%
994	1	< 0.1%
1015	1	< 0.1%
1095	1	< 0.1%
1167	1	< 0.1%
1187	1	< 0.1%
1222	1	< 0.1%
1256	1	< 0.1%

Value	Count	Frequency (%)
2352	1	< 0.1%
2295	1	< 0.1%
2237	1	< 0.1%
2224	1	< 0.1%
2221	2	< 0.1%
2217	1	< 0.1%
2212	1	< 0.1%
2200	1	< 0.1%
2191	1	< 0.1%
2188	2	< 0.1%

ZZ
Real number (ℝ_≥0)

MISSING

Distinct	41
Distinct (%)	0.5%
Missing	194
Missing (%)	2.3%
Infinite	0
Infinite (%)	0.0%
Mean	11.63438806

Minimum	1
Maximum	56
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.1 KiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	9
median	11
Q3	13
95-th percentile	21
Maximum	56
Range	55
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	4.470727126
Coefficient of variation (CV)	0.3842683519
Kurtosis	5.172523215
Mean	11.63438806
Median Absolute Deviation (MAD)	2
Skewness	1.766666583
Sum	97438
Variance	19.98740103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
9	1135	13.2%
10	1061	12.4%
8	1033	12.1%
11	867	10.1%
12	763	8.9%
7	657	7.7%
13	538	6.3%
14	417	4.9%
15	304	3.5%
16	280	3.3%
Other values (31)	1320	15.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	0.1%
2	1	< 0.1%
4	1	< 0.1%
5	27	0.3%
6	256	3.0%
7	657	7.7%
8	1033	12.1%
9	1135	13.2%
10	1061	12.4%
11	867	10.1%

Value	Count	Frequency (%)
56	1	< 0.1%
42	2	< 0.1%
40	1	< 0.1%
39	1	< 0.1%
38	2	< 0.1%
37	2	< 0.1%
36	2	< 0.1%
35	5	0.1%
34	4	< 0.1%
33	4	< 0.1%

number
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	39
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5066.964873

Minimum	5048
Maximum	5086
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	67.1 KiB

Quantile statistics

Minimum	5048
5-th percentile	5050
Q1	5057
median	5067
Q3	5077
95-th percentile	5084
Maximum	5086
Range	38
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	11.15463223
Coefficient of variation (CV)	0.002201442581
Kurtosis	-1.176528849
Mean	5066.964873
Median Absolute Deviation (MAD)	10
Skewness	-0.01898982193
Sum	43418822
Variance	124.4258201
Monotonicity	Increasing

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
5084	277	3.2%
5058	271	3.2%
5061	270	3.2%
5074	268	3.1%
5066	268	3.1%
5071	266	3.1%
5050	265	3.1%
5083	265	3.1%
5081	264	3.1%
5077	263	3.1%
Other values (29)	5892	68.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5048	215	2.5%
5049	212	2.5%
5050	265	3.1%
5051	254	3.0%
5052	175	2.0%
5053	182	2.1%
5054	251	2.9%
5055	166	1.9%
5056	244	2.8%
5057	182	2.1%

Value	Count	Frequency (%)
5086	170	2.0%
5085	173	2.0%
5084	277	3.2%
5083	265	3.1%
5082	179	2.1%
5081	264	3.1%
5080	161	1.9%
5079	181	2.1%
5078	224	2.6%
5077	263	3.1%

list
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	8569
Missing (%)	100.0%
Memory size	67.1 KiB

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	time	SDDY	XCLL	LSP	YHLND	DJWD	FZB	GZDY	PJDY	XLCS	ZZ	number	list
0	2021-08-07 00:00:00	4.065	2620.0	NaN	1.71	NaN	2.61	4.076	4.076	1525.0	8.0	5048	NaN
1	2021-08-09 00:00:00	4.065	2620.0	90.0	1.70	928.0	2.65	4.107	4.093	1487.0	11.0	5048	NaN
2	2021-08-10 00:00:00	4.065	2650.0	60.0	1.70	928.0	2.65	4.096	4.080	1711.0	9.0	5048	NaN
3	2021-08-11 00:00:00	4.065	2620.0	70.0	1.70	932.0	2.65	4.112	4.080	1586.0	7.0	5048	NaN
4	2021-08-12 00:00:00	4.065	2620.0	90.0	1.70	928.0	2.65	4.094	4.093	1450.0	8.0	5048	NaN
5	2021-08-13 00:00:00	4.065	2620.0	70.0	1.70	922.0	2.65	4.093	4.089	1520.0	9.0	5048	NaN
6	2021-08-14 00:00:00	4.065	2650.0	80.0	1.70	923.0	2.65	4.095	4.096	1538.0	7.0	5048	NaN
7	2021-08-15 00:00:00	4.065	2650.0	80.0	1.70	927.0	2.65	4.134	4.094	1503.0	9.0	5048	NaN
8	2021-08-16 00:00:00	4.065	2650.0	70.0	1.63	926.0	2.65	4.105	4.083	1624.0	8.0	5048	NaN
9	2021-08-17 00:00:00	4.065	2650.0	80.0	1.63	926.0	2.65	4.090	4.090	1445.0	8.0	5048	NaN

Last rows

	time	SDDY	XCLL	LSP	YHLND	DJWD	FZB	GZDY	PJDY	XLCS	ZZ	number	list
8559	2022-05-13 00:00:00	4.02	2790.0	27.0	1.49	932.0	2.64	4.046	4.047	1849.0	12.0	5086	NaN
8560	2022-05-14 00:00:00	4.02	2790.0	28.0	1.49	928.0	2.64	4.043	4.046	1838.0	14.0	5086	NaN
8561	2022-05-15 00:00:00	4.02	2790.0	27.0	1.49	929.0	2.64	4.039	4.045	1808.0	11.0	5086	NaN
8562	2022-05-16 00:00:00	4.02	2790.0	27.0	1.49	938.0	2.64	4.060	4.068	1921.0	13.0	5086	NaN
8563	2022-05-17 00:00:00	4.02	2790.0	27.0	1.49	938.0	2.64	4.071	4.096	1764.0	12.0	5086	NaN
8564	2022-05-18 00:00:00	4.02	2790.0	27.0	1.95	930.0	2.63	4.073	4.078	1855.0	15.0	5086	NaN
8565	2022-05-19 00:00:00	4.02	2790.0	27.0	1.95	931.0	2.63	4.060	4.060	1829.0	20.0	5086	NaN
8566	2022-05-20 00:00:00	4.02	2790.0	27.0	1.95	931.0	2.63	4.058	4.074	1960.0	9.0	5086	NaN
8567	2022-05-21 00:00:00	4.02	2790.0	27.0	1.95	933.0	2.63	4.051	4.051	1920.0	10.0	5086	NaN
8568	2022-05-22 00:00:00	4.02	2790.0	27.0	1.95	935.0	2.63	4.059	4.060	1799.0	10.0	5086	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows